Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SchoolID (FK)(PK) | A unique retailer assigned identifier for an educational institution that a Worker may attend, as well as working for the Retailer. | ID_SCHL | Identity | integer | School(PA_SCHL) |
WorkerID (FK)(PK) | A unique system-assigned identifier for the Person who is a particular Worker. | ID_WRKR | Identity | integer | Worker(PA_WRKR) |
EffectiveDate | The date from which the nominated Worker is enrolled at the nominated School. | DC_EF | EffectiveDate | date | |
ExpirationDate | The date from which the nominated Worker is no longer enrolled at the nominated School | DC_EP | ExpirationDate | date | |